I need to calculate the number of days between a BBE date and todays date
I’ve tried using a previous example from an expert on here but it just returns error every time
Currently using
=DAY([BBE DATE])-DAY(TODAY())
Cells formatted to Auto
Error
#VALUE!
Formula contains a value that conflicts with its function or operation
Hi there @Cliv-cd10,
how about using DAYS formula instead, if the aim is to calculate difference between dates?
Regards.
Hi
Do you have an example in this please
Just something I can hopefully try to copy and adapt to my columns
Thanks
Using an app the user inputs month and year for BBE date
The table then makes the date using
=[BBE month]&”/31/“&[BBE year]
Not overly concerned that not every month has 31 days as not enough to worry about for this
Something so simple in Microsoft excel that just doesn’t want to know in here
Hi @Cliv-cd10,
I hope you are doing well. I tried to mimic your scenario. There are three fields on the screen: BBE Date, Today's date, and a field to calculate the difference between two dates. Below is a screenshot.
For the date difference, I have used the expression “=If($[BBE Date]="", 0, DAYS($[BBE Date],$[Today date])).
Here is the gif from runtime.
Hope this helps.
Thanks for the reply
This needs to be done in a table and not on an app screen
Any suggestions for that welcomed
Thanks
Hi @Cliv-cd10,
Thank you for clarifying.
The same formula can optionally be used in table columns. Create two columns Date1 and Date2. Using Column Properties, set them up as Date format columns. For the third column, you can use DAYS to calculate the days between columns. Please see below screenshot.
I hope this helps.
