•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula edit for finding out a date when criteria are met
I have three columns, one is start date (P3), one is end date(Q3), and one is total time (R3). I have the time one set right now with
=DATEDIF(P3,TODAY(),"y")&"y "&DATEDIF(P3,TODAY(),"ym")&"m "&DATEDIF(P3,TODAY(),"md")&"d"
so it will show a running total of how long it has been from start to today. I want to have it so once you enter a date in the end date column it uses that as the end date instead of calculating to today.
Can someone help me with that?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#formula generator
#DATEDIF
#start date
#end date
#total time
#formula
#today
#running total
#Excel
#criteria