Sign in to join the conversation:
The NETDAYS between 5-Aug-2018 and 9-Aug-2018 is coming as 36530. I don't know what's happening - can anybody help?
=NETDAYS([Last Date Entered]4, Today4)
The same formula in another sheet is working absolutely fine.
Re-type your dates in. Looks like you accidentally put in 2118 instead of 2018 for the year, but since it's formatted as YY instead of YYYY, it looks right.
Good catch Javed!
Craig
Hi There, I'd like to count the cells which year belongs to 2024, seems the formula I wrote cannot capture the correct volume, may I seek your help for it? which part is wrong in my formula? Details as following: My formula: Reference column: Thanks in advance!
I wanted to join the text(PM names,ID) in two or more cells which is basically multivalue cells and display the same one below other and also i want the duplicate names also to be displayed
=IF([Due Date]@row > TODAY(), IF(AND(Status@row = "In Progress", Status@row = "New", Status@row = "Not Started"), "Yes", "No"))) The goal is to flag items for escalation based on the due date and status. If the due date is in the past and the status of the risk or decision is in progress, not started, or new then I need to…
