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.
New contributor
matthew Kegel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.