=IFERROR(Rounddown(datedif(B2,C2,"D")/7)) Make this show the weeks up to the date even if I don't have an end date yet
In google sheets I am using this formula to currently calculate the amount of time that has taken place between two dates. =IFERROR(Rounddown(datedif(B2,C2,"D")/7))
Is there something I can add to this formula to make it show the number of weeks up to todays current date? Currently it only shows me the weeks between the dates if I have an end date.
I think I showed above, that is all I have tried. I am not sure what to google to get the results Im looking for.
Solution
Here's another method you may try:
=ARRAYFORMULA(IF(NOT(ISBLANK(A2:A)), ARRAYFORMULA(IF(B2:B = "", FLOOR((NOW()-A2:A)/7), FLOOR((B2:B-A2:A)/7))), " "))
This should also resolve the part where you're getting random numbers on cells that don't have any start and end dates.
- How do I compare new IDs with a column of existing IDs and allowcate a timestamp if two IDs match on Google Sheets?
- Resolving TypeError when trying to use findIndex
- oauth 2 parameters can only have a single value: scope
- Show next row as soon as a cell is filled, using a macro
- Getting Sheet to Modify It with Apps Script
- How can i write to a specific cell in a Google sheets range?
- How can i read and write to cells in the same function?
- The download /back-up of Google scripts (.gs files) bounded to Google Spreadsheets
- Did Google Sheets stop allowing json access?
- How to connect Google Sheets to Database
- Access Google Sheets on Google Colaboratory
- How to delete all rows hidden by user
- Google sheet API pricing
- Question on google sheets URL from another language, like VB
- Insert image into Google Sheets cell using Google Sheets API
- Error in deploying shinyapp using leaflet and googlesheets API
- Send event from Google Spreadsheet to a Chrome extension
- Formatting cells with the Google Sheets API (v4)
- What is the most efficient way to get borders in Google Apps Script
- =IFERROR(Rounddown(datedif(B2,C2,"D")/7)) Make this show the weeks up to the date even if I don't have an end date yet
- gpsread Google Sheets Protect Worksheet with Warning
- How can I use specific cells in a Google sheets range?
- Google API: Loop through mySQL results to add multiple rows to Google Sheet
- Google Sheets API - Bolding and Highlighting text
- How to identify cell is merged cell with google sheets api using python
- How to append a row to Google Sheets API? It's not working with Jquery: code 403 Unregistered callers
- Using Sheets.Spreadsheets.Values.update() Correctly
- How get raw cell data from google sheets?
- javascript read google sheet value.getBatch issue
- How to extract url from Google Sheet Cell with anchor text hyperlink