web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Building APP - formula...

Power Apps

Answered

Building APP - formula for Sharepoint list

(0) Share

Report

Report

Posted on by maries1986

162

Hi! I had a hunt for something the same as this but SharePoint....no luck! i am building an app on the list but i need help with a formula. I have a date column and a month column. i pull the month from the date using a formula.

I need to have a column that gives me the number for days in the month.

=IF(ISBLANK([Install Date]),"",((MONTH([Install date]),"D")

This is probably very wrong.....does anyone know the formula to calculate this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try using a Switch:

Switch(MONTH([Install date]), 1,31, 2,28, 3,31, 4,30, 5,31, 6,30, 7,31, 8,31, 9,30, 10,31, 11,30, 12,31 )

Was this reply helpful? Yes No
Verified answer

maries1986 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @BCLS776 i actually got it!

=IF(ISBLANK([Install date]),"",DAY(DATE(YEAR([Install date]),MONTH([Install date])+1,1)-1))

Was this reply helpful? Yes No

Join the conversation